Stored Procedures [dbo].[BAEOrderCategoryParentLookupDelete]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@OrderCategoryIDint4
@OrderCategoryParentIDint4
SQL Script
create procedure [dbo].[BAEOrderCategoryParentLookupDelete] @OrderCategoryID as
int,
    @OrderCategoryParentID AS int
AS
    DELETE
    FROM OrderCategoryParentLookup
    WHERE OrderCategoryID = @OrderCategoryID AND
    OrderCategoryParentID = @OrderCategoryParentID;

GO
Uses